{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Disclaimer","Linear Interpolation","Slope Intersection","Slope Calculator"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":27,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Linear Interpolation","index":1,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Point","Station","Elevation",null,null,null,null,"Point","X","Y"]
["Slope",1,11211.5,3908.93,null,null,null,null,4,1.7932999999999999,1.4]
[{"$f":"(D5-D3)/(C5-C3)","v":-1.9999999999527063E-3},2,11213,{"$f":"D3-(((C3-C4)*(D3-D5))/((C3-C5)))","v":3908.9269999999997},null,"Y2 =",{"$f":"ROUND(D4,2)","v":3908.93},null,5,0.15820000000000001,{"$f":"K3*J4/J3","v":0.12350415435231138},null,"Y5 =",{"$f":"ROUND(K4,1)","v":0.1}]
[null,3,11216.5,3908.92]
[]
[null,"FORMAT:",null,null,null,null,null,"FORMAT:"]
[]
[]
[]
[]
[null,"Point","X","Y"]
["FILL",1,0,3908.53]
["IN CZ",2,1.5,{"$f":"D13-(((C13-C14)*(D13-D15))/((C13-C15)))","v":3908.6375000000003},null,"Y2 =",{"$f":"ROUND(D14,2)","v":3908.64}]
[null,3,6,3908.96]
[]
[null,"Point","X","Y",null,null,null,null,"Point","X","Y"]
["FILL",1,0,3937.48,null,null,null,null,1,13050,61.905000000000001]
["OUT CZ",2,1.5880000000000001,{"$f":"D18-(((C18-C19)*(D18-D20))/((C18-C20)))","v":3937.4551729529021},null,"Y2 =",{"$f":"ROUND(D19,2)","v":3937.46},null,2,13000,{"$f":"K18-(((J18-J19)*(K18-K20))/((J18-J20)))","v":55.083500000000001},null,"Y2 =",{"$f":"ROUND(K19,2)","v":55.08}]
[null,3,10.234,3937.32,null,null,null,null,3,12950,48.262]
[]
[null,"Point","X","Y"]
["FILL",1,0,3937.98]
["OUT CZ",2,2.597,{"$f":"D23-(((C23-C24)*(D23-D25))/((C23-C25)))","v":3937.9332673521853},null,"Y2 =",{"$f":"ROUND(D24,2)","v":3937.93}]
[null,3,7.78,3937.84]
[]
[null,"Point","X","Y"]
["CUT",1,0.5,44]
[null,2,0.8,{"$f":"D28-(((C28-C29)*(D28-D30))/((C28-C30)))","v":61.400000000000006},null,"Y2 =",{"$f":"ROUND(D29,2)","v":61.4}]
[null,3,1,73]
[]
[null,"Point","X","Y"]
["CUT",1,2958.09,4047.0472]
[null,2,3186.44,{"$f":"D33-(((C33-C34)*(D33-D35))/((C33-C35)))","v":4046.4152188042431},null,"Y2 =",{"$f":"ROUND(D34,2)","v":4046.42}]
[null,3,3206.97,4046.3584000000001]

{"sheet":"Slope Intersection","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Line A"]
["Point 1",null,null,"Point 2",null,null,"Equation"]
["Location (x1)","Elevation (y1)",null,"Location (x2)","Elevation (y2)",null,"y=mx+b","m","b",null,"y","x",null,"SOLVER"]
[5,2104.2800000000002,null,11.423,2104.75,null,null,{"$f":"(E4-B4)/(D4-A4)","v":7.3174529036244731E-2},{"$f":"B4-H4*A4","v":2103.9141273548189},null,{"$f":"H4*L4+I4","v":2102.7407134092769},-16.035825047278983,null,{"$f":"K4-K9","v":-6.2807293943478726E-7}]
[]
["Line B"]
["Point 1",null,null,"Point 2",null,null,"Equation"]
["Location (x1)","Elevation (y1)",null,"Location (x2)","Elevation (y2)",null,"y=mx+b","m","b",null,"y","x"]
[0,2103.6999999999998,null,11.2,2104.37,null,null,{"$f":"(E9-B9)/(D9-A9)","v":5.9821428571435069E-2},{"$f":"B9-H9*A9","v":2103.6999999999998},null,{"$f":"H9*L9+I9","v":2102.7407140373498},{"$f":"L4","v":-16.035825047278983}]

{"sheet":"Slope Calculator","index":3,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Point A",null,null,null,null,null,"Point B"]
["Location (x1)","Elevation (y1)",null,"Slope =",{"$f":"(H4-B4)/(G4-A4)","v":-6.8571428571366205E-3},null,"Location (x2)","Elevation (y2)"]
[0,2798.02,null,null,null,null,35,2797.78]